Jeff Reisman
Jeff Reisman
-
Re: CountIF for whole column Not just a range of rows
@Alison Laninger , When referencing an entire column in the same sheet, the format is [Column Name]:[Column Name]. How you create your formula for this count depends on your data. If the value you ar…2 · -
Re: Help Extracting data sets that meet criteria to new sheet.
You may have to sign out of Smartsheet and sign back in, or delete your browser cache.1 · -
Re: exclude the link to the sheet in automation email
@Shwetaic In the workflow, under the Alert action, click "Customize message". Next, under "Message includes," select "Message only."1 · -
Re: How do I add up times?
@TeeM In Smartsheet, numbers entered in this fashion (hh:mm) are stored as text, and therefore math won't work on them without some help. We can use the VALUE, LEN, LEFT, and RIGHT functions to isola…1 · -
Re: How to auto-trigger a flag in smartsheet?
@LaurGrad Similar to the formula above, use an IF function in the Flag column: =IF([Severance?]@row = "Yes", 1, 0) Here's more info about the IF function: https://help.smartsheet.com/functi…1 ·
